Hi All,

This error is now stopping all my spreadsheets using a data model (power pivot and power query) from working.

Seems to have been caused by the install of one/all of the following:

KB2768005

KB2768016

KB2956151

KB2837655

Any idea which one? 

I have tried to get the hotfix (KB2837666) as described in these historical posts but now get an error saying that the page is no longer available (after clicking on the download link)

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2013/11/12/powerpivot-for-excel-2013-errors-after-october-update-kb-2825655.aspx

http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/invalid-pointer-array/4df45729-5d78-4e6a-8f82-c4d38060c977

hotfix KB2837666

One post suggested turning off the "prefer the Excel Data Model" (advanced options) but this made no difference for me.

Running Office Pro plus 32bit on a win 8.1 64bit. Excel version 15.0.4701

• Edited by PomKey Monday, March 30, 2015 9:24 PM

Hi,

For the hot fix, please try this url, let me know if the hotfix works for you. Thank you.

• Proposed as answer by Chloe WangMicrosoft employee, Moderator Thursday, April 09, 2015 1:26 PM
• Marked as answer by Chloe WangMicrosoft employee, Moderator Monday, April 13, 2015 4:43 AM

We resolved this by removing KB2920753. 

we will try the hotfix next time the issue occurs.